﻿<cfsilent>
	<cfscript>
	event.setArg("pageTitle", "学籍异动通知单" );
	changeID = event.getArg("DOCID");

	sql = "SELECT b.sct_name,a.class_name,
				   a.institute_name,a.subject_name,
				   a.grade,c.stu_name,
				   a.stu_id,a.op_description
			FROM t_stuchange a 
				 INNER JOIN t_stuchange_type b ON b.sct_code = a.sct_code 
				 INNER JOIN t_student c ON c.stu_id = a.stu_id 
			WHERE a.stuchg_id = :changeID ";
			
	queryObj = new Query( datasource=application.dnsSlave );
	queryObj.addParam( name="changeID", value=changeID, cfsqltype = "cf_sql_char");

	rs_studentChange = queryObj.execute( sql=sql ).getResult();
	</cfscript>
</cfsilent>
<cfif rs_studentChange.recordCount GT 0>
<cfloop from="1" to="5" index="p">
<div id="sampleContent">
	<div class="UIprintableTitle">西南科技大学<cfoutput>#rs_studentChange.sct_name#</cfoutput>通知</div>
	<table width="98%" border="0" cellpadding="1" cellspacing="0">
	<tbody>
        <tr>
           <td>
		   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<cfif rs_studentChange.class_name neq ""><cfoutput>#rs_studentChange.institute_name#</cfoutput><cfoutput>#rs_studentChange.subject_name#</cfoutput>专业<cfoutput>#rs_studentChange.grade#</cfoutput>级<cfoutput>#rs_studentChange.class_name#</cfoutput>班,</cfif>
		   学生<cfoutput>#rs_studentChange.stu_name#</cfoutput>，学号<cfoutput>#rs_studentChange.stu_id#</cfoutput>，<cfoutput>#rs_studentChange.op_description#</cfoutput>，经个人申请，学校审批，同意其<cfoutput>#rs_studentChange.sct_name#</cfoutput>。
		   </td>
         </tr>
		<tr>
		   <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;请做好与你办相关工作，特此通知</td>
		</tr>
		<tr>
		   <td>&nbsp;&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
           <td align="right">西南科技大学教务处</td>
        </tr>
		
	</tbody>
		<div class="clear2px"></div>
	<table width="100%" cellpadding="0" cellspacing="0">
	<tbody>
		 <tr>
			<td width="150" align="right">打印日期 <cfoutput>#dateFormat(now(), "YYYY年MM月DD日")#</cfoutput></td>
		 </tr> 
	</tbody>
	</table>
	</div>
		<br/><br/><br/>
</cfloop>
</cfif>